Query with MySQL join is slow is there a way to improve slow performance with subquery